Advanced Excel Success by Alan Murray

Author:Alan Murray
Language: eng
Format: epub, azw3
ISBN: 9781484264676
Publisher: Apress

Let us look at some useful examples of custom number formatting.

Combine Text and Numbers in a Cell

Excel provides formatting options for currency, percentages, dates, and more, but it has not covered everything, and you may need to create your own formats.

For example, we have a list of weights which are measured in kilograms. We want to create a format with the unit symbol “kg” after the numeric value.

In the Type box of Format Cells, enter the following format code:0.00 "kg"

This formats the values to two decimal places and follows the value with the text string “kg” (Figure 3-36).

Figure 3-36Combine text and numbers in a cell

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.